-
Re: Nominate Peak Humans & get a badge!
I have to second (or third ... or fourth ... or eleventeenth) the nominations for @Paul Newcome and @Genevieve P. I consistently see them helping the community, and both of the have helped me solve r…5 · -
Re: Hello, How do I add a 3rd column to create a metric sheet.
Hey, Mark. I did this assuming that you have two separate sheets - one for tracking each week's site visit volume by provider and week, then the other (the one in lilac) for aggregating the weekly si…1 · -
Re: Collecting dates prior to today
Hi, Joe. It's not entirely clear what you want to count. Are you trying to count the number of departments that have identified a defect in the past week (7 days before today)? Are you expecting each…1 · -
Re: Status Change Formula Unparseable
@ccarriger probably has the right idea here given the complexity of what you want to achieve. But, whether you do this as an automated workflow or a formula, the conditions are challenging, because w…1 · -
Re: If formula for multiple check boxes.
You have an extra comma in your formula before the close parenthesis for the AND Once you remove that, you should be set!1 ·